UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'opQORKqRxwj0m0Z8yLlHxutYG9J86HVGgE48oiHKW+E='
WHERE
key_id = '622788ca32a3ab6d4f8510ddd1e5f2142b896fea0be385d00d27cd9e2abdcdf2'
AND (
token = 'opQORKqRxwj0m0Z8yLlHxutYG9J86HVGgE48oiHKW+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)