UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xiHFnG9HK7mUFhWGxDUvDunbCf8bRXYI3PMwKjTKV+k='
WHERE
key_id = '8b15acd0fcdbce48d4c3e305b6d730c01226d3482c6d0db44e5c8962ed19ca85'
AND (
token = 'xiHFnG9HK7mUFhWGxDUvDunbCf8bRXYI3PMwKjTKV+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)