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