UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kSp1XHAAh7wVHHHE6XGSgBUDwr6A0offZMLGRQOsL/4='
WHERE
key_id = 'aca99ced4ddd8b27edab06c5bee8c551ac668ea41aa4165bb66123122332119f'
AND (
token = 'kSp1XHAAh7wVHHHE6XGSgBUDwr6A0offZMLGRQOsL/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)