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