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