UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jl7aIrTnBxkKEF4e/V0HKUIfXUJSAVftUDF28Q9q+CQ='
WHERE
key_id = '76e8a86de78e2dc808187ab77f78fc61a9eb80023d8f4cc4033a386428d9d3a2'
AND (
token = 'jl7aIrTnBxkKEF4e/V0HKUIfXUJSAVftUDF28Q9q+CQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)