UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0eH4oY3CMg6NNq9vE780Ac3KhD/9Egq65ajuS+zds3Y='
WHERE
key_id = '2a6c09897d39856bb8c21a79a91c4773b97fc3b0232fda6e28be8644b92df171'
AND (
token = '0eH4oY3CMg6NNq9vE780Ac3KhD/9Egq65ajuS+zds3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)