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