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