UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nC5F9NKL4JJtZE8pQ7D7JYjuNuGqeSFNdYBTZ5Z67YQ='
WHERE
key_id = '169e35bbd27e893700ea5c2fcbf33f9f70e10d41125ac0b797cd1dfa13c9e626'
AND (
token = 'nC5F9NKL4JJtZE8pQ7D7JYjuNuGqeSFNdYBTZ5Z67YQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)