UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pUXi834YqifsqZS3fwcty8Wg6El2lcrPpHJ0nCOubuA='
WHERE
key_id = 'd7cbe2df4dbace43f0f5aadb8b539ac391c5f4548342631c17b00aa8bf4fe932'
AND (
token = 'pUXi834YqifsqZS3fwcty8Wg6El2lcrPpHJ0nCOubuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)