UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'icFVoSerQxmgHXbwsRIIxX47RPEEtIv90HMJ89oLVSs='
WHERE
key_id = '406507891ad8fda8092e0b386a44d5a3d39138a67dc1fda508948ef0bd44353e'
AND (
token = 'icFVoSerQxmgHXbwsRIIxX47RPEEtIv90HMJ89oLVSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)