UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1mkFuqcM8pqHb5bNzvtY2EK/vOEDXt7hi5Sfnj8zFAA='
WHERE
key_id = 'ac9c0c72c18f252f97728a5be0e64f042e3c9bc7bdb3e9bbb6d40bddc45ad84d'
AND (
token = '1mkFuqcM8pqHb5bNzvtY2EK/vOEDXt7hi5Sfnj8zFAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)