UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oTqtdwcYK2LcODNOiuWkY8rlqrrgkY2+6citD1xEses='
WHERE
key_id = '7f9d6c237c93845f61147287a198e919422a86bf095eebb086ecad1a755cd689'
AND (
token = 'oTqtdwcYK2LcODNOiuWkY8rlqrrgkY2+6citD1xEses='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)