UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xTDJ8Ba1AqSI7zC7yiQXRq5d4+bdiwbIcN8fT/R3Tvo='
WHERE
key_id = 'bc327b52eaad053e02357b42d97c6c5f5570742ab6c38ce603b44f2f307aecbf'
AND (
token = 'xTDJ8Ba1AqSI7zC7yiQXRq5d4+bdiwbIcN8fT/R3Tvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)