UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9tlLh+S4XnsSQkBblL5OCWTpc23h9c9wrVY6G30tFWM='
WHERE
key_id = '075b892ab15fad8bc4cf2b972a91394df4fe6619662c1fa4b292d5d3b351705a'
AND (
token = '9tlLh+S4XnsSQkBblL5OCWTpc23h9c9wrVY6G30tFWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)