UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cfmE3sLCYN/xKE23ci2yDuF+InHOcab9mXJvgua6qb8='
WHERE
key_id = '4d548a84d01df22aea88f51dd14cd5b8fba366854a89aa11cc92251a987a8930'
AND (
token = 'cfmE3sLCYN/xKE23ci2yDuF+InHOcab9mXJvgua6qb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)