UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o9ePlNKRiWx2pnP48OXBp1GKYt/tHg9LsAv4cgJSkz8='
WHERE
key_id = '67dc625fcc53935336d84d0772f6e470c31a342a681a310c02ee40fb4575d78a'
AND (
token = 'o9ePlNKRiWx2pnP48OXBp1GKYt/tHg9LsAv4cgJSkz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)