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