UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZmxGypZWUk1eki1kGe5+q+OA4BNi2cZVgiFrTL4YVHc='
WHERE
key_id = '4bfb9d724ef73b913b9c2c44d1abaf83af28978ea3b2ea90abd02a675b657962'
AND (
token = 'ZmxGypZWUk1eki1kGe5+q+OA4BNi2cZVgiFrTL4YVHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)