UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XUKyqkS0pHt2eDbpnFE0savfWpaJSHToAXPlE9MCIXs='
WHERE
key_id = '2e6f696a9ce5f383946063fa1bf22d378d8f9f28d3b369eba038b9b5519cdffc'
AND (
token = 'XUKyqkS0pHt2eDbpnFE0savfWpaJSHToAXPlE9MCIXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)