UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HznumJALCybIgpm2CjbrQIi9vU59NxHYjNPCZJK6KLs='
WHERE
key_id = 'b611de6791c16e3df7e1fdd9b8f2765af2a23175a585ab7f30dd505f98bd800a'
AND (
token = 'HznumJALCybIgpm2CjbrQIi9vU59NxHYjNPCZJK6KLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)