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