UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7EFCkPGc2L8r1H8u3N12KhIjsThugdMXT+kvNIavZfU='
WHERE
key_id = 'cf7599bc1b96353119ce540c5a926f7f441a872a1e6e5d09818b00610258431b'
AND (
token = '7EFCkPGc2L8r1H8u3N12KhIjsThugdMXT+kvNIavZfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)