UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kzUCiyKWIbJ+SFsDNrUhfQ6aLY8RkUZPSBGJZKvTLk0='
WHERE
key_id = '7802a7ea86821fe4dcf50ce45c5367c3cf7a68fac5abfbed9fa73c5e4b51d8af'
AND (
token = 'kzUCiyKWIbJ+SFsDNrUhfQ6aLY8RkUZPSBGJZKvTLk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)