UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RezlIZAkVQkNWb3tu9a3JhWYthTiKmPIgcZzgBNg4qQ='
WHERE
key_id = 'acac620e875f2757e984c76863aaa3a9ff249d85e09dfe617ebc6289657ea53e'
AND (
token = 'RezlIZAkVQkNWb3tu9a3JhWYthTiKmPIgcZzgBNg4qQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)