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