UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fdSnqrHPvYLaIsdCHPXutak5NlN6IQiQ9fb+4+4vK2w='
WHERE
key_id = '7b6f452e548fae791445d1b0c40a8b3e0b24d689ace42cd9c2178190ac62551a'
AND (
token = 'fdSnqrHPvYLaIsdCHPXutak5NlN6IQiQ9fb+4+4vK2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)