UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/As7nKPlTgNLkVBLdIYAfvdDblpiu4Ti1DwLppPkpOI='
WHERE
key_id = '2b9294d3e5d49f3cefe5a06d89263a677a38ef53a31f023e63c401013a8efbf1'
AND (
token = '/As7nKPlTgNLkVBLdIYAfvdDblpiu4Ti1DwLppPkpOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)