UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zrrPVqmSKvsH/2zSXwLBiUtuH0vCHiSr2W55qCy+S/o='
WHERE
key_id = '20c152a347bc73abe2b59ff33f2acea8db4868faa02133105da42c4bbb172b89'
AND (
token = 'zrrPVqmSKvsH/2zSXwLBiUtuH0vCHiSr2W55qCy+S/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)