UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/NKsHaBNqeXoIJEmK7Um7SFgYrTD9BTJgin3pPQfkoU='
WHERE
key_id = 'b1e620caf32d1731fd0e4b036094b01ba6a89ccceadb6b67be981eaef1783c62'
AND (
token = '/NKsHaBNqeXoIJEmK7Um7SFgYrTD9BTJgin3pPQfkoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)