UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcZgCP4gSc8kxNBP8E0XWU58+aTBhtAqWBK3YrQTMis='
WHERE
key_id = 'd033cfef168db428a08c80c341f33c459d880a6a650443d166f03ee75ebaf4c8'
AND (
token = 'bcZgCP4gSc8kxNBP8E0XWU58+aTBhtAqWBK3YrQTMis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)