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