UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D2RFnH+0nk99ApiWp5G8pb14CiUW86GsTyNOBsG424U='
WHERE
key_id = 'd05687bcb74013aa7bf41db415728e32fd762336d1cc36b1e82e64fb1a10d93c'
AND (
token = 'D2RFnH+0nk99ApiWp5G8pb14CiUW86GsTyNOBsG424U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)